Compiling Spreadsheet-Defined Functions
نویسنده
چکیده
Spreadsheets are ubiquitous end-user programming tools, but lack even the simplest abstraction mechanism: The ability to encapsulate a computation as a function. This paper presents a solution in the form of sheetdefined functions, which are built from well-known spreadsheet cells, formulas and references. They should be understandable to most spreadsheet users, yet offer far more programming power than standard spreadsheet programs. We present a prototype implementation of sheet-defined functions and several example applications. We show that they can perform as well as built-in functions and better than external languages such as VBA.
منابع مشابه
User Defined Spreadsheet Functions in Excel
Creating user defined functions (UDFs) is a powerful method to improve the quality of computer applications, in particular spreadsheets. However, the only direct way to use UDFs in spreadsheets is to switch from the functional and declarative style of spreadsheet formulas to the imperative VBA, which creates a high entry barrier even for proficient spreadsheet users. It has been proposed to ext...
متن کاملDetermination of e ω , e e x ω , e B , and e α using potential energy functions for heteronuclear diatomic molecules via spreadsheet program
In order to represent the potential energy function over the whole range of R, many potentialenergy functions have been proposed. In the present paper, we employ many potential energyfunctions, to use Numerov method for solving the nuclear Schrödinger equation for the IFmolecule, as an example of a heteronuclear diatomic molecules. Then we determine thespectroscopic constants eω , e e x ω , e B...
متن کاملOnline partial evaluation of sheet-defined functions
We present a spreadsheet implementation, extended with sheet-defined functions, that allows users to define functions using only standard spreadsheet concepts such as cells, formulas and references, requiring no new syntax. This implements an idea proposed by Peyton-Jones and others [13]. As the main contribution of this paper, we then show how to add an online partial evaluator for such sheet-...
متن کاملSheet-Defined Functions: Implementation and Initial Evaluation
Spreadsheets are ubiquitous end-user programming tools, but lack even the simplest abstraction mechanism: The ability to encapsulate a computation as a function. This was observed by Peyton-Jones and others [14], who proposed a mechanism to define such functions using only standard spreadsheet cells, formulas and references. This paper extends their work by increasing expressiveness and emphasi...
متن کاملRewriting High-Level Spreadsheet Structures into Higher-Order Functional Programs
Spreadsheets are used heavily in industry and academia. Often, spreadsheet models are developed for years and their complexity grows vastly beyond what the paradigm was originally conceived for. Such complexity often comes at the cost of recalculation performance. However, spreadsheet models usually have some high-level structure that can be used to improve performance by performing independent...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2010